{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row0_col1 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row0_col2 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row0_col3 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row1_col1 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row1_col2 {\n",
       "            color: black;\n",
       "            background-color: lime;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row1_col3 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row2_col1 {\n",
       "            color: red;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row2_col2 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row2_col3 {\n",
       "            color: red;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row3_col1 {\n",
       "            color: red;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row3_col2 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row3_col3 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row4_col1 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row4_col2 {\n",
       "            color: red;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row4_col3 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row5_col1 {\n",
       "            color: red;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row5_col2 {\n",
       "            color: black;\n",
       "            background-color: lime;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row5_col3 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row6_col1 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row6_col2 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row6_col3 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row7_col1 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row7_col2 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row7_col3 {\n",
       "            color: red;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row8_col1 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row8_col2 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row8_col3 {\n",
       "            color: red;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row9_col1 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row9_col2 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row9_col3 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row10_col1 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row10_col2 {\n",
       "            color: red;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row10_col3 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row11_col1 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row11_col2 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row11_col3 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row12_col1 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row12_col2 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row12_col3 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row13_col1 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row13_col2 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row13_col3 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row14_col1 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row14_col2 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row14_col3 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row15_col1 {\n",
       "            color: red;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row15_col2 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row15_col3 {\n",
       "            color: red;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row16_col1 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row16_col2 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row16_col3 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row17_col1 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row17_col2 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row17_col3 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row18_col1 {\n",
       "            color: black;\n",
       "            background-color: lime;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row18_col2 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row18_col3 {\n",
       "            color: red;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row19_col1 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row19_col2 {\n",
       "            color: black;\n",
       "            background-color: white;\n",
       "        }    #T_be28201a_4409_11ed_a7fe_4c1d96487f19row19_col3 {\n",
       "            color: black;\n",
       "            background-color: lime;\n",
       "        }</style><table id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >Name</th>        <th class=\"col_heading level0 col1\" >Test_1</th>        <th class=\"col_heading level0 col2\" >Test_2</th>        <th class=\"col_heading level0 col3\" >Test_3</th>    </tr>    <tr>        <th class=\"index_name level0\" >ID</th>        <th class=\"blank\" ></th>        <th class=\"blank\" ></th>        <th class=\"blank\" ></th>        <th class=\"blank\" ></th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19level0_row0\" class=\"row_heading level0 row0\" >1</th>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row0_col0\" class=\"data row0 col0\" >Student_001</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row0_col1\" class=\"data row0 col1\" >62</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row0_col2\" class=\"data row0 col2\" >86</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row0_col3\" class=\"data row0 col3\" >83</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19level0_row1\" class=\"row_heading level0 row1\" >2</th>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row1_col0\" class=\"data row1 col0\" >Student_002</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row1_col1\" class=\"data row1 col1\" >77</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row1_col2\" class=\"data row1 col2\" >97</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row1_col3\" class=\"data row1 col3\" >78</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19level0_row2\" class=\"row_heading level0 row2\" >3</th>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row2_col0\" class=\"data row2 col0\" >Student_003</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row2_col1\" class=\"data row2 col1\" >57</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row2_col2\" class=\"data row2 col2\" >96</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row2_col3\" class=\"data row2 col3\" >46</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19level0_row3\" class=\"row_heading level0 row3\" >4</th>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row3_col0\" class=\"data row3 col0\" >Student_004</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row3_col1\" class=\"data row3 col1\" >57</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row3_col2\" class=\"data row3 col2\" >87</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row3_col3\" class=\"data row3 col3\" >80</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19level0_row4\" class=\"row_heading level0 row4\" >5</th>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row4_col0\" class=\"data row4 col0\" >Student_005</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row4_col1\" class=\"data row4 col1\" >95</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row4_col2\" class=\"data row4 col2\" >59</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row4_col3\" class=\"data row4 col3\" >87</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19level0_row5\" class=\"row_heading level0 row5\" >6</th>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row5_col0\" class=\"data row5 col0\" >Student_006</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row5_col1\" class=\"data row5 col1\" >56</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row5_col2\" class=\"data row5 col2\" >97</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row5_col3\" class=\"data row5 col3\" >61</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19level0_row6\" class=\"row_heading level0 row6\" >7</th>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row6_col0\" class=\"data row6 col0\" >Student_007</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row6_col1\" class=\"data row6 col1\" >64</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row6_col2\" class=\"data row6 col2\" >91</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row6_col3\" class=\"data row6 col3\" >67</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19level0_row7\" class=\"row_heading level0 row7\" >8</th>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row7_col0\" class=\"data row7 col0\" >Student_008</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row7_col1\" class=\"data row7 col1\" >96</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row7_col2\" class=\"data row7 col2\" >70</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row7_col3\" class=\"data row7 col3\" >48</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19level0_row8\" class=\"row_heading level0 row8\" >9</th>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row8_col0\" class=\"data row8 col0\" >Student_009</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row8_col1\" class=\"data row8 col1\" >77</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row8_col2\" class=\"data row8 col2\" >73</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row8_col3\" class=\"data row8 col3\" >48</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19level0_row9\" class=\"row_heading level0 row9\" >10</th>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row9_col0\" class=\"data row9 col0\" >Student_010</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row9_col1\" class=\"data row9 col1\" >90</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row9_col2\" class=\"data row9 col2\" >94</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row9_col3\" class=\"data row9 col3\" >67</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19level0_row10\" class=\"row_heading level0 row10\" >11</th>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row10_col0\" class=\"data row10 col0\" >Student_011</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row10_col1\" class=\"data row10 col1\" >62</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row10_col2\" class=\"data row10 col2\" >55</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row10_col3\" class=\"data row10 col3\" >63</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19level0_row11\" class=\"row_heading level0 row11\" >12</th>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row11_col0\" class=\"data row11 col0\" >Student_012</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row11_col1\" class=\"data row11 col1\" >83</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row11_col2\" class=\"data row11 col2\" >76</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row11_col3\" class=\"data row11 col3\" >81</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19level0_row12\" class=\"row_heading level0 row12\" >13</th>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row12_col0\" class=\"data row12 col0\" >Student_013</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row12_col1\" class=\"data row12 col1\" >68</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row12_col2\" class=\"data row12 col2\" >60</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row12_col3\" class=\"data row12 col3\" >90</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19level0_row13\" class=\"row_heading level0 row13\" >14</th>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row13_col0\" class=\"data row13 col0\" >Student_014</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row13_col1\" class=\"data row13 col1\" >82</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row13_col2\" class=\"data row13 col2\" >68</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row13_col3\" class=\"data row13 col3\" >98</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19level0_row14\" class=\"row_heading level0 row14\" >15</th>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row14_col0\" class=\"data row14 col0\" >Student_015</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row14_col1\" class=\"data row14 col1\" >61</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row14_col2\" class=\"data row14 col2\" >67</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row14_col3\" class=\"data row14 col3\" >91</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19level0_row15\" class=\"row_heading level0 row15\" >16</th>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row15_col0\" class=\"data row15 col0\" >Student_016</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row15_col1\" class=\"data row15 col1\" >59</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row15_col2\" class=\"data row15 col2\" >63</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row15_col3\" class=\"data row15 col3\" >46</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19level0_row16\" class=\"row_heading level0 row16\" >17</th>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row16_col0\" class=\"data row16 col0\" >Student_017</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row16_col1\" class=\"data row16 col1\" >62</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row16_col2\" class=\"data row16 col2\" >83</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row16_col3\" class=\"data row16 col3\" >93</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19level0_row17\" class=\"row_heading level0 row17\" >18</th>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row17_col0\" class=\"data row17 col0\" >Student_018</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row17_col1\" class=\"data row17 col1\" >90</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row17_col2\" class=\"data row17 col2\" >75</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row17_col3\" class=\"data row17 col3\" >80</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19level0_row18\" class=\"row_heading level0 row18\" >19</th>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row18_col0\" class=\"data row18 col0\" >Student_019</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row18_col1\" class=\"data row18 col1\" >100</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row18_col2\" class=\"data row18 col2\" >95</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row18_col3\" class=\"data row18 col3\" >55</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19level0_row19\" class=\"row_heading level0 row19\" >20</th>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row19_col0\" class=\"data row19 col0\" >Student_020</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row19_col1\" class=\"data row19 col1\" >61</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row19_col2\" class=\"data row19 col2\" >87</td>\n",
       "                        <td id=\"T_be28201a_4409_11ed_a7fe_4c1d96487f19row19_col3\" class=\"data row19 col3\" >100</td>\n",
       "            </tr>\n",
       "    </tbody></table>"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x17d125241f0>"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "def low_score_red(s):  \n",
    "    if s<60:\n",
    "        color=\"red\"\n",
    "    else:\n",
    "        color=\"black\"\n",
    "    return f'color:{color}'\n",
    "\n",
    "def highest_score_green(col): \n",
    "    return [\"background-color:lime\" if s==col.max() else 'background-color:white' for s in col]\n",
    "\n",
    "students = pd.read_excel('Students.xlsx', index_col='ID')\n",
    "students.style.applymap(low_score_red,subset=['Test_1', 'Test_2', 'Test_3']).apply(highest_score_green,subset=['Test_1', 'Test_2', 'Test_3'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "    #T_ab989808_4409_11ed_b63c_4c1d96487f19row0_col1 {\n",
       "            background-color:  #c7eec7;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row0_col2 {\n",
       "            background-color:  #3ca13c;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row0_col3 {\n",
       "            background-color:  #48a848;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row1_col1 {\n",
       "            background-color:  #78c278;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row1_col2 {\n",
       "            background-color:  #008000;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row1_col3 {\n",
       "            background-color:  #5eb45e;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row2_col1 {\n",
       "            background-color:  #e1fde1;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row2_col2 {\n",
       "            background-color:  #058305;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row2_col3 {\n",
       "            background-color:  #e5ffe5;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row3_col1 {\n",
       "            background-color:  #e1fde1;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row3_col2 {\n",
       "            background-color:  #369e36;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row3_col3 {\n",
       "            background-color:  #55af55;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row4_col1 {\n",
       "            background-color:  #1a8e1a;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row4_col2 {\n",
       "            background-color:  #d0f3d0;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row4_col3 {\n",
       "            background-color:  #379e37;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row5_col1 {\n",
       "            background-color:  #e5ffe5;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row5_col2 {\n",
       "            background-color:  #008000;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row5_col3 {\n",
       "            background-color:  #a6dca6;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row6_col1 {\n",
       "            background-color:  #bce8bc;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row6_col2 {\n",
       "            background-color:  #209220;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row6_col3 {\n",
       "            background-color:  #8cce8c;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row7_col1 {\n",
       "            background-color:  #158b15;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row7_col2 {\n",
       "            background-color:  #94d294;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row7_col3 {\n",
       "            background-color:  #ddfbdd;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row8_col1 {\n",
       "            background-color:  #78c278;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row8_col2 {\n",
       "            background-color:  #83c983;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row8_col3 {\n",
       "            background-color:  #ddfbdd;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row9_col1 {\n",
       "            background-color:  #349d34;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row9_col2 {\n",
       "            background-color:  #108910;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row9_col3 {\n",
       "            background-color:  #8cce8c;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row10_col1 {\n",
       "            background-color:  #c7eec7;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row10_col2 {\n",
       "            background-color:  #e5ffe5;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row10_col3 {\n",
       "            background-color:  #9ed79e;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row11_col1 {\n",
       "            background-color:  #58b158;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row11_col2 {\n",
       "            background-color:  #72bf72;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row11_col3 {\n",
       "            background-color:  #51ad51;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row12_col1 {\n",
       "            background-color:  #a7dda7;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row12_col2 {\n",
       "            background-color:  #caf0ca;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row12_col3 {\n",
       "            background-color:  #2a972a;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row13_col1 {\n",
       "            background-color:  #5eb45e;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row13_col2 {\n",
       "            background-color:  #9ed89e;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row13_col3 {\n",
       "            background-color:  #088408;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row14_col1 {\n",
       "            background-color:  #cbf1cb;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row14_col2 {\n",
       "            background-color:  #a4dba4;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row14_col3 {\n",
       "            background-color:  #269526;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row15_col1 {\n",
       "            background-color:  #d6f7d6;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row15_col2 {\n",
       "            background-color:  #bae7ba;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row15_col3 {\n",
       "            background-color:  #e5ffe5;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row16_col1 {\n",
       "            background-color:  #c7eec7;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row16_col2 {\n",
       "            background-color:  #4daa4d;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row16_col3 {\n",
       "            background-color:  #1e901e;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row17_col1 {\n",
       "            background-color:  #349d34;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row17_col2 {\n",
       "            background-color:  #79c379;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row17_col3 {\n",
       "            background-color:  #55af55;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row18_col1 {\n",
       "            background-color:  #008000;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row18_col2 {\n",
       "            background-color:  #0b860b;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row18_col3 {\n",
       "            background-color:  #c0eac0;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row19_col1 {\n",
       "            background-color:  #cbf1cb;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row19_col2 {\n",
       "            background-color:  #369e36;\n",
       "            color:  #000000;\n",
       "        }    #T_ab989808_4409_11ed_b63c_4c1d96487f19row19_col3 {\n",
       "            background-color:  #008000;\n",
       "            color:  #f1f1f1;\n",
       "        }</style><table id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >Name</th>        <th class=\"col_heading level0 col1\" >Test_1</th>        <th class=\"col_heading level0 col2\" >Test_2</th>        <th class=\"col_heading level0 col3\" >Test_3</th>    </tr>    <tr>        <th class=\"index_name level0\" >ID</th>        <th class=\"blank\" ></th>        <th class=\"blank\" ></th>        <th class=\"blank\" ></th>        <th class=\"blank\" ></th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19level0_row0\" class=\"row_heading level0 row0\" >1</th>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row0_col0\" class=\"data row0 col0\" >Student_001</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row0_col1\" class=\"data row0 col1\" >62</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row0_col2\" class=\"data row0 col2\" >86</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row0_col3\" class=\"data row0 col3\" >83</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19level0_row1\" class=\"row_heading level0 row1\" >2</th>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row1_col0\" class=\"data row1 col0\" >Student_002</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row1_col1\" class=\"data row1 col1\" >77</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row1_col2\" class=\"data row1 col2\" >97</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row1_col3\" class=\"data row1 col3\" >78</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19level0_row2\" class=\"row_heading level0 row2\" >3</th>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row2_col0\" class=\"data row2 col0\" >Student_003</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row2_col1\" class=\"data row2 col1\" >57</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row2_col2\" class=\"data row2 col2\" >96</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row2_col3\" class=\"data row2 col3\" >46</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19level0_row3\" class=\"row_heading level0 row3\" >4</th>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row3_col0\" class=\"data row3 col0\" >Student_004</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row3_col1\" class=\"data row3 col1\" >57</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row3_col2\" class=\"data row3 col2\" >87</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row3_col3\" class=\"data row3 col3\" >80</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19level0_row4\" class=\"row_heading level0 row4\" >5</th>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row4_col0\" class=\"data row4 col0\" >Student_005</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row4_col1\" class=\"data row4 col1\" >95</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row4_col2\" class=\"data row4 col2\" >59</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row4_col3\" class=\"data row4 col3\" >87</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19level0_row5\" class=\"row_heading level0 row5\" >6</th>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row5_col0\" class=\"data row5 col0\" >Student_006</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row5_col1\" class=\"data row5 col1\" >56</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row5_col2\" class=\"data row5 col2\" >97</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row5_col3\" class=\"data row5 col3\" >61</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19level0_row6\" class=\"row_heading level0 row6\" >7</th>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row6_col0\" class=\"data row6 col0\" >Student_007</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row6_col1\" class=\"data row6 col1\" >64</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row6_col2\" class=\"data row6 col2\" >91</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row6_col3\" class=\"data row6 col3\" >67</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19level0_row7\" class=\"row_heading level0 row7\" >8</th>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row7_col0\" class=\"data row7 col0\" >Student_008</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row7_col1\" class=\"data row7 col1\" >96</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row7_col2\" class=\"data row7 col2\" >70</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row7_col3\" class=\"data row7 col3\" >48</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19level0_row8\" class=\"row_heading level0 row8\" >9</th>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row8_col0\" class=\"data row8 col0\" >Student_009</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row8_col1\" class=\"data row8 col1\" >77</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row8_col2\" class=\"data row8 col2\" >73</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row8_col3\" class=\"data row8 col3\" >48</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19level0_row9\" class=\"row_heading level0 row9\" >10</th>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row9_col0\" class=\"data row9 col0\" >Student_010</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row9_col1\" class=\"data row9 col1\" >90</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row9_col2\" class=\"data row9 col2\" >94</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row9_col3\" class=\"data row9 col3\" >67</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19level0_row10\" class=\"row_heading level0 row10\" >11</th>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row10_col0\" class=\"data row10 col0\" >Student_011</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row10_col1\" class=\"data row10 col1\" >62</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row10_col2\" class=\"data row10 col2\" >55</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row10_col3\" class=\"data row10 col3\" >63</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19level0_row11\" class=\"row_heading level0 row11\" >12</th>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row11_col0\" class=\"data row11 col0\" >Student_012</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row11_col1\" class=\"data row11 col1\" >83</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row11_col2\" class=\"data row11 col2\" >76</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row11_col3\" class=\"data row11 col3\" >81</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19level0_row12\" class=\"row_heading level0 row12\" >13</th>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row12_col0\" class=\"data row12 col0\" >Student_013</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row12_col1\" class=\"data row12 col1\" >68</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row12_col2\" class=\"data row12 col2\" >60</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row12_col3\" class=\"data row12 col3\" >90</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19level0_row13\" class=\"row_heading level0 row13\" >14</th>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row13_col0\" class=\"data row13 col0\" >Student_014</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row13_col1\" class=\"data row13 col1\" >82</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row13_col2\" class=\"data row13 col2\" >68</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row13_col3\" class=\"data row13 col3\" >98</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19level0_row14\" class=\"row_heading level0 row14\" >15</th>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row14_col0\" class=\"data row14 col0\" >Student_015</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row14_col1\" class=\"data row14 col1\" >61</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row14_col2\" class=\"data row14 col2\" >67</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row14_col3\" class=\"data row14 col3\" >91</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19level0_row15\" class=\"row_heading level0 row15\" >16</th>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row15_col0\" class=\"data row15 col0\" >Student_016</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row15_col1\" class=\"data row15 col1\" >59</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row15_col2\" class=\"data row15 col2\" >63</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row15_col3\" class=\"data row15 col3\" >46</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19level0_row16\" class=\"row_heading level0 row16\" >17</th>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row16_col0\" class=\"data row16 col0\" >Student_017</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row16_col1\" class=\"data row16 col1\" >62</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row16_col2\" class=\"data row16 col2\" >83</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row16_col3\" class=\"data row16 col3\" >93</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19level0_row17\" class=\"row_heading level0 row17\" >18</th>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row17_col0\" class=\"data row17 col0\" >Student_018</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row17_col1\" class=\"data row17 col1\" >90</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row17_col2\" class=\"data row17 col2\" >75</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row17_col3\" class=\"data row17 col3\" >80</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19level0_row18\" class=\"row_heading level0 row18\" >19</th>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row18_col0\" class=\"data row18 col0\" >Student_019</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row18_col1\" class=\"data row18 col1\" >100</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row18_col2\" class=\"data row18 col2\" >95</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row18_col3\" class=\"data row18 col3\" >55</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19level0_row19\" class=\"row_heading level0 row19\" >20</th>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row19_col0\" class=\"data row19 col0\" >Student_020</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row19_col1\" class=\"data row19 col1\" >61</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row19_col2\" class=\"data row19 col2\" >87</td>\n",
       "                        <td id=\"T_ab989808_4409_11ed_b63c_4c1d96487f19row19_col3\" class=\"data row19 col3\" >100</td>\n",
       "            </tr>\n",
       "    </tbody></table>"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x17d125293d0>"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "\n",
    "color_map=sns.light_palette('green', as_cmap=True)#调色板\n",
    "students = pd.read_excel('Students.xlsx', index_col='ID')\n",
    "students.style.background_gradient(color_map,subset=['Test_1', 'Test_2', 'Test_3']) #subset选择数据区域"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row0_col1 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 13.6%, transparent 13.6%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row0_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 73.8%, transparent 73.8%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row0_col3 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 68.5%, transparent 68.5%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row1_col1 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 47.7%, transparent 47.7%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row1_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 100.0%, transparent 100.0%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row1_col3 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 59.3%, transparent 59.3%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row2_col1 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 2.3%, transparent 2.3%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row2_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 97.6%, transparent 97.6%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row2_col3 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row3_col1 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 2.3%, transparent 2.3%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row3_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 76.2%, transparent 76.2%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row3_col3 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 63.0%, transparent 63.0%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row4_col1 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 88.6%, transparent 88.6%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row4_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 9.5%, transparent 9.5%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row4_col3 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 75.9%, transparent 75.9%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row5_col1 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row5_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 100.0%, transparent 100.0%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row5_col3 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 27.8%, transparent 27.8%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row6_col1 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 18.2%, transparent 18.2%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row6_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 85.7%, transparent 85.7%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row6_col3 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 38.9%, transparent 38.9%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row7_col1 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 90.9%, transparent 90.9%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row7_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 35.7%, transparent 35.7%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row7_col3 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 3.7%, transparent 3.7%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row8_col1 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 47.7%, transparent 47.7%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row8_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 42.9%, transparent 42.9%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row8_col3 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 3.7%, transparent 3.7%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row9_col1 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 77.3%, transparent 77.3%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row9_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 92.9%, transparent 92.9%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row9_col3 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 38.9%, transparent 38.9%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row10_col1 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 13.6%, transparent 13.6%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row10_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row10_col3 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 31.5%, transparent 31.5%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row11_col1 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 61.4%, transparent 61.4%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row11_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 50.0%, transparent 50.0%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row11_col3 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 64.8%, transparent 64.8%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row12_col1 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 27.3%, transparent 27.3%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row12_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 11.9%, transparent 11.9%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row12_col3 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 81.5%, transparent 81.5%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row13_col1 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 59.1%, transparent 59.1%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row13_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 31.0%, transparent 31.0%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row13_col3 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 96.3%, transparent 96.3%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row14_col1 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 11.4%, transparent 11.4%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row14_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 28.6%, transparent 28.6%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row14_col3 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 83.3%, transparent 83.3%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row15_col1 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 6.8%, transparent 6.8%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row15_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 19.0%, transparent 19.0%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row15_col3 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row16_col1 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 13.6%, transparent 13.6%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row16_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 66.7%, transparent 66.7%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row16_col3 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 87.0%, transparent 87.0%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row17_col1 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 77.3%, transparent 77.3%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row17_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 47.6%, transparent 47.6%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row17_col3 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 63.0%, transparent 63.0%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row18_col1 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 100.0%, transparent 100.0%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row18_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 95.2%, transparent 95.2%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row18_col3 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 16.7%, transparent 16.7%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row19_col1 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 11.4%, transparent 11.4%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row19_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 76.2%, transparent 76.2%);\n",
       "        }    #T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row19_col3 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,orange 100.0%, transparent 100.0%);\n",
       "        }</style><table id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >Name</th>        <th class=\"col_heading level0 col1\" >Test_1</th>        <th class=\"col_heading level0 col2\" >Test_2</th>        <th class=\"col_heading level0 col3\" >Test_3</th>    </tr>    <tr>        <th class=\"index_name level0\" >ID</th>        <th class=\"blank\" ></th>        <th class=\"blank\" ></th>        <th class=\"blank\" ></th>        <th class=\"blank\" ></th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19level0_row0\" class=\"row_heading level0 row0\" >1</th>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row0_col0\" class=\"data row0 col0\" >Student_001</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row0_col1\" class=\"data row0 col1\" >62</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row0_col2\" class=\"data row0 col2\" >86</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row0_col3\" class=\"data row0 col3\" >83</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19level0_row1\" class=\"row_heading level0 row1\" >2</th>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row1_col0\" class=\"data row1 col0\" >Student_002</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row1_col1\" class=\"data row1 col1\" >77</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row1_col2\" class=\"data row1 col2\" >97</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row1_col3\" class=\"data row1 col3\" >78</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19level0_row2\" class=\"row_heading level0 row2\" >3</th>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row2_col0\" class=\"data row2 col0\" >Student_003</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row2_col1\" class=\"data row2 col1\" >57</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row2_col2\" class=\"data row2 col2\" >96</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row2_col3\" class=\"data row2 col3\" >46</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19level0_row3\" class=\"row_heading level0 row3\" >4</th>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row3_col0\" class=\"data row3 col0\" >Student_004</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row3_col1\" class=\"data row3 col1\" >57</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row3_col2\" class=\"data row3 col2\" >87</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row3_col3\" class=\"data row3 col3\" >80</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19level0_row4\" class=\"row_heading level0 row4\" >5</th>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row4_col0\" class=\"data row4 col0\" >Student_005</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row4_col1\" class=\"data row4 col1\" >95</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row4_col2\" class=\"data row4 col2\" >59</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row4_col3\" class=\"data row4 col3\" >87</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19level0_row5\" class=\"row_heading level0 row5\" >6</th>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row5_col0\" class=\"data row5 col0\" >Student_006</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row5_col1\" class=\"data row5 col1\" >56</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row5_col2\" class=\"data row5 col2\" >97</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row5_col3\" class=\"data row5 col3\" >61</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19level0_row6\" class=\"row_heading level0 row6\" >7</th>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row6_col0\" class=\"data row6 col0\" >Student_007</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row6_col1\" class=\"data row6 col1\" >64</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row6_col2\" class=\"data row6 col2\" >91</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row6_col3\" class=\"data row6 col3\" >67</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19level0_row7\" class=\"row_heading level0 row7\" >8</th>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row7_col0\" class=\"data row7 col0\" >Student_008</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row7_col1\" class=\"data row7 col1\" >96</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row7_col2\" class=\"data row7 col2\" >70</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row7_col3\" class=\"data row7 col3\" >48</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19level0_row8\" class=\"row_heading level0 row8\" >9</th>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row8_col0\" class=\"data row8 col0\" >Student_009</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row8_col1\" class=\"data row8 col1\" >77</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row8_col2\" class=\"data row8 col2\" >73</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row8_col3\" class=\"data row8 col3\" >48</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19level0_row9\" class=\"row_heading level0 row9\" >10</th>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row9_col0\" class=\"data row9 col0\" >Student_010</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row9_col1\" class=\"data row9 col1\" >90</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row9_col2\" class=\"data row9 col2\" >94</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row9_col3\" class=\"data row9 col3\" >67</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19level0_row10\" class=\"row_heading level0 row10\" >11</th>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row10_col0\" class=\"data row10 col0\" >Student_011</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row10_col1\" class=\"data row10 col1\" >62</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row10_col2\" class=\"data row10 col2\" >55</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row10_col3\" class=\"data row10 col3\" >63</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19level0_row11\" class=\"row_heading level0 row11\" >12</th>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row11_col0\" class=\"data row11 col0\" >Student_012</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row11_col1\" class=\"data row11 col1\" >83</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row11_col2\" class=\"data row11 col2\" >76</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row11_col3\" class=\"data row11 col3\" >81</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19level0_row12\" class=\"row_heading level0 row12\" >13</th>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row12_col0\" class=\"data row12 col0\" >Student_013</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row12_col1\" class=\"data row12 col1\" >68</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row12_col2\" class=\"data row12 col2\" >60</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row12_col3\" class=\"data row12 col3\" >90</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19level0_row13\" class=\"row_heading level0 row13\" >14</th>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row13_col0\" class=\"data row13 col0\" >Student_014</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row13_col1\" class=\"data row13 col1\" >82</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row13_col2\" class=\"data row13 col2\" >68</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row13_col3\" class=\"data row13 col3\" >98</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19level0_row14\" class=\"row_heading level0 row14\" >15</th>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row14_col0\" class=\"data row14 col0\" >Student_015</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row14_col1\" class=\"data row14 col1\" >61</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row14_col2\" class=\"data row14 col2\" >67</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row14_col3\" class=\"data row14 col3\" >91</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19level0_row15\" class=\"row_heading level0 row15\" >16</th>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row15_col0\" class=\"data row15 col0\" >Student_016</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row15_col1\" class=\"data row15 col1\" >59</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row15_col2\" class=\"data row15 col2\" >63</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row15_col3\" class=\"data row15 col3\" >46</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19level0_row16\" class=\"row_heading level0 row16\" >17</th>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row16_col0\" class=\"data row16 col0\" >Student_017</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row16_col1\" class=\"data row16 col1\" >62</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row16_col2\" class=\"data row16 col2\" >83</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row16_col3\" class=\"data row16 col3\" >93</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19level0_row17\" class=\"row_heading level0 row17\" >18</th>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row17_col0\" class=\"data row17 col0\" >Student_018</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row17_col1\" class=\"data row17 col1\" >90</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row17_col2\" class=\"data row17 col2\" >75</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row17_col3\" class=\"data row17 col3\" >80</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19level0_row18\" class=\"row_heading level0 row18\" >19</th>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row18_col0\" class=\"data row18 col0\" >Student_019</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row18_col1\" class=\"data row18 col1\" >100</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row18_col2\" class=\"data row18 col2\" >95</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row18_col3\" class=\"data row18 col3\" >55</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19level0_row19\" class=\"row_heading level0 row19\" >20</th>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row19_col0\" class=\"data row19 col0\" >Student_020</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row19_col1\" class=\"data row19 col1\" >61</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row19_col2\" class=\"data row19 col2\" >87</td>\n",
       "                        <td id=\"T_ed6fb31b_4409_11ed_9b90_4c1d96487f19row19_col3\" class=\"data row19 col3\" >100</td>\n",
       "            </tr>\n",
       "    </tbody></table>"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x17d177d0040>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "students = pd.read_excel('Students.xlsx', index_col='ID')\n",
    "students.style.bar(color=\"orange\",subset=['Test_1', 'Test_2', 'Test_3']) #subset选择数据区域"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
